﻿<%@ Page Title="" Language="C#" MasterPageFile="~/teacheryemian/teachermain.Master" AutoEventWireup="true" CodeBehind="teachengjibianji.aspx.cs" Inherits="zlh.teacheryemian.teachengjibianji" %>
<asp:Content ID="Content1" ContentPlaceHolderID="teaContentPlaceHolder1" runat="server">
    <p>
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        <asp:Label ID="Label11" runat="server" Text="学号：" CssClass="word"></asp:Label>
        <asp:TextBox ID="TextBox10" runat="server" CssClass="textbox"></asp:TextBox>
        <asp:Button ID="Button1" runat="server" CssClass="button" Text="查询" />
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" AllowPaging="True" HorizontalAlign="Center" PageSize="5" Width="728px">
            <Columns>
                <asp:BoundField DataField="xueqi" HeaderText="xueqi" SortExpression="xueqi" />
                <asp:BoundField DataField="stuNo" HeaderText="stuNo" SortExpression="stuNo" />
                <asp:BoundField DataField="stuName" HeaderText="stuName" SortExpression="stuName" />
                <asp:BoundField DataField="CourseName" HeaderText="CourseName" SortExpression="CourseName" />
                <asp:BoundField DataField="grade" HeaderText="grade" SortExpression="grade" />
                <asp:BoundField DataField="Coursexuefen" HeaderText="Coursexuefen" SortExpression="Coursexuefen" />
                <asp:BoundField DataField="Class" HeaderText="Class" SortExpression="Class" />
            </Columns>
            <HeaderStyle CssClass="gridxiewHeaderstyle" />
            <RowStyle CssClass="gridviewrowstyle" />
        </asp:GridView>
        </p>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:dhd2014112130ConnectionString6 %>" SelectCommand="SELECT * FROM [Grades] WHERE ([stuNo] = @stuNo)">
            <SelectParameters>
                <asp:ControlParameter ControlID="TextBox10" Name="stuNo" PropertyName="Text" Type="String" />
            </SelectParameters>
        </asp:SqlDataSource>
    <p>
        &nbsp;</p>
    <p>
        &nbsp;</p>
    <p>
        &nbsp;</p>
    <p>
        &nbsp;</p>
    <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:dhd2014112130ConnectionString6 %>" SelectCommand="SELECT * FROM [Grades]">
        </asp:SqlDataSource>
    <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource2" AllowPaging="True" HorizontalAlign="Center" PageSize="5" Width="754px" style="margin-top: 0px">
            <Columns>
                <asp:BoundField DataField="xueqi" HeaderText="xueqi" SortExpression="xueqi" />
                <asp:BoundField DataField="stuNo" HeaderText="stuNo" SortExpression="stuNo" />
                <asp:BoundField DataField="stuName" HeaderText="stuName" SortExpression="stuName" />
                <asp:BoundField DataField="CourseName" HeaderText="CourseName" SortExpression="CourseName" />
                <asp:BoundField DataField="grade" HeaderText="grade" SortExpression="grade" />
                <asp:BoundField DataField="Coursexuefen" HeaderText="Coursexuefen" SortExpression="Coursexuefen" />
                <asp:BoundField DataField="Class" HeaderText="Class" SortExpression="Class" />
            </Columns>
            <HeaderStyle CssClass="gridxiewHeaderstyle" />
            <RowStyle CssClass="gridviewrowstyle" />
        </asp:GridView>
        </asp:Content>
